install_driver(Oracle) failed while connecting to oracle 10.2.0.2
install_driver(Oracle) failed while connecting to oracle 10.2.0.2
am 20.02.2007 14:16:40 von rchelikam
------_=_NextPart_001_01C754F1.5B924345
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
HI
Could u pls help on this issue.
=20
Presently we are using the following versions=20
=20
Perl version -------- perl, v5.6.1 built for sun4-solaris
DBD::ORACLE --------- 1.15
DBI version ---------- 1.28
ORACLE -------- oracle 10.2.0.2
=20
=20
=20
THE BELOW CODE WAS WORKING FINE WITH ORACLE 9.2.0.8
=20
=20
=20
use DBI;
print "hi";
=20
print "\n";
=20
print "\n befor connecting to test server \n";
# oracle 9i testing for foxtrot
$dbh =3D DBI->connect("dbi:Oracle:servername",'username','password',
{RaiseError =3D> 1, AutoCommit =3D> 1}) or
die "Can't connect to database $DBI::errstr\n";
=20
=20
# Put together your query string
my $sql =3D 'select * from db_intf where intf_id=3D22816 ';
# Instead you could do $dbh->do($sql) or execute
$sth =3D $dbh->prepare($sql);
$sth->execute();
=20
print "\n connected";
print"\n";
while (@rows =3D $sth->fetchrow_array()) {=20
=20
# You can access a specific field like this: $rows[0];=20
print "@rows\t";
}=20
print "\n";$sth->finish();
$dbh->disconnect();
=20
print "\n DISconnected";
print"\n";
=20
=20
We have migrated the oracle from 9.2.0.8 to 10g (10.2.0.2)
=20
And I used the same code as above, I got the below error
=20
=20
install_driver(Oracle) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBD/ Oracle/Oracl
e.so' for module DBD::Oracle: ld.so.1:=20
perl: fatal:
/usr/local/opt/oracle/product/ldcnmd/lib32/libclntsh.so.9.0: Permission
denied at /usr/local/lib/perl5/5.6.1/sun4-solaris/DynaLoader.pm line
206.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at a.pl line 25
=20
=20
=20
could u plz let me know, what I have to do for this error.
Should I change the DBI and DBD versions for compatibility with oracle
10g.=20
if, so what driver versions are compatible with oracle 10g + perl 5.6.1
And also how to complile the DBD:Oracle driver
=20
Early response is highly appreciated.
Thanks in Advance
=20
=20
Thanks & Regards
Ravi
=20
=20
=20
=20
=20
=20
=20
=20
________________________________
From: Sachin Deshmukh=20
Sent: Tuesday, January 23, 2007 7:07 PM
To: RaviChandra Chelikam
Cc: G Ramana
Subject: G RamanaRE: Regarding Oracle 10g Upgrade
=20
Awaiting for your findings...
=20
________________________________
From: G Ramana=20
Sent: Tuesday, January 23, 2007 6:47 PM
To: Sachin Deshmukh
Cc: RaviChandra Chelikam
Subject: RE: Regarding Oracle 10g Upgrade
Sachin,
=20
Following activities are done since last 2 days.
=20
1. Oracle10g Express edition installed successfully on my machine.
=20
2. Exported CNM data from ldncnm7 schema on dev server to local machines
=20
3. Imported CNM data in oracle successfully but all temporary tables are
getting invalid because oracle installer don't have licensee (Partitions
not supported)
=20
4. Created all table spaces for LD database
=20
5. Created all users using by CNM like ldncnm7_app_be,.....etc
=20
Need more time to execute all database objects are getting to valid
state
=20
Need to work on following activities
=20
1. Need to again install oracle10g licensee version
2. Need to Work on compilation of database objects
3. Need to connect and test application with oracle10g
=20
after complete above activities I can give the correct analysis to you.
=20
Thanks & Regards,
Ramana GYV
=20
________________________________
From: Sachin Deshmukh=20
Sent: Friday, January 19, 2007 12:10 PM
To: G Ramana; RaviChandra Chelikam
Subject: Regarding Oracle 10g Upgrade
Ramana/Ravi:
Let me know the exact impact of Oracle 10g upgrade on CNM Application.
=20
Following are some of the things which needs to be considered :
- Do we need to modify the DB Scripts
- Do we need to upgrade the Oracle driver which is used by perl
scripts
if yes, then what all changes are required in the existing
perl scripts
- Do we need to upgrade our JDBC driver (UI Module) for Oracle 10g
database
if yes then what all changes are required in the UI module
- Do we need some configuration for the Oracle Queues
- Is there any feature of Oracle 9i which CNM App is using but not
supported by Oracle 10g
=20
These are some of the basic areas to be considered but you need to
consider all the area which has dependency on database.
=20
Ravi, you have to take care of BE & UI modules & Ramana needs to
investigate into DB scripts, Queues and anything specific to DB
features, configuration, compatibility.
=20
You need to go through the documentation provided for Oracle 10g DB.
=20
Let me know your finding by 24th Jan EOD.
=20
=20
Regards,
=20
Sachin Deshmukh
==================== =====3D=
==================== =====3D=
==================== =====3D=
==================== =====3D=
==================== ====
Tech Mahindra, formerly Mahindra-British Telecom.
=20
Disclaimer:
This message and the information contained herein is proprietary and=
confidential and subject to the Tech Mahindra policy statement, you may=
review at
=3D"http://www.techmahindra.com/Disclaimer.html">http://www. techmahindra.co=
m/Disclaimer.html externally and
=3D"http://tim.techmahindra.com/Disclaimer.html">http://tim. techmahindra.co=
m/Disclaimer.html internally within Tech Mahindra.
==================== =====3D=
==================== =====3D=
==================== =====3D=
==================== =====3D=
==================== ====
------_=_NextPart_001_01C754F1.5B924345--
RE: install_driver(Oracle) failed while connecting to oracle 10.2.0.2
am 20.02.2007 17:16:37 von Philip.Garrett
Hi,
RaviChandra Chelikam wrote:
>=20
> perl: fatal:
> /usr/local/opt/oracle/product/ldcnmd/lib32/libclntsh.so.9.0:
> Permission denied at .....
^^^^^^^^^^^^^^^^^
The permissions on your Oracle installation are not letting Perl load
the Oracle client library. The library file libclntsh.so.9.0 (or one of
the directories leading to it more likely) is not accessible as the user
running the Perl script. Fix the permissions and your program will
probably work ok.
Regards,
Philip
RE: install_driver(Oracle) failed while connecting to oracle
am 20.02.2007 19:23:15 von rchelikam
------_=_NextPart_001_01C7551C.302725D3
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
Philip
We have Changed the permissions .
Even after that, I am getting the following error as
=20
=20
install_driver(Oracle) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBD/ Oracle/Oracl
e.so' for module DBD::Oracle: ld.so.1: perl: fatal: libclntsh.so.9.0:
open failed: No such file or directory at
/usr/local/lib/perl5/5.6.1/sun4-solaris/DynaLoader.pm line 206.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at a.pl line 25
=20
=20
=20
Actually it is searching for libclntsh.so.9.0(since the previous oracle
version was 9i) in /usr/local/opt/oracle/product/10.2.0/lib32/and=20
Failing to open the file.
But since we migrated to 10g now
/usr/local/opt/oracle/product/10.2.0/lib32/ is having libclntsh.so.10.1
=20
So, what should I do ,to point to libclntsh.so.10.1 instead of
libclntsh.so.9.0
=20
=20
=20
Thanks & Regards
Ravi
=20
-----Original Message-----
From: Garrett, Philip (MAN-Corporate)
[mailto:Philip.Garrett@manheim.com]=20
Sent: Tuesday, February 20, 2007 9:47 PM
To: RaviChandra Chelikam; dbi-users@perl.org
Subject: RE: install_driver(Oracle) failed while connecting to oracle
10.2.0.2
=20
Hi,
=20
RaviChandra Chelikam wrote:
>=20
> perl: fatal:
> /usr/local/opt/oracle/product/ldcnmd/lib32/libclntsh.so.9.0:
> Permission denied at .....
^^^^^^^^^^^^^^^^^
=20
The permissions on your Oracle installation are not letting Perl load
the Oracle client library. The library file libclntsh.so.9.0 (or one of
the directories leading to it more likely) is not accessible as the user
running the Perl script. Fix the permissions and your program will
probably work ok.
=20
Regards,
Philip
==================== =====3D=
==================== =====3D=
==================== =====3D=
==================== =====3D=
==================== ====
Tech Mahindra, formerly Mahindra-British Telecom.
=20
Disclaimer:
This message and the information contained herein is proprietary and=
confidential and subject to the Tech Mahindra policy statement, you may=
review at
=3D"http://www.techmahindra.com/Disclaimer.html">http://www. techmahindra.co=
m/Disclaimer.html externally and
=3D"http://tim.techmahindra.com/Disclaimer.html">http://tim. techmahindra.co=
m/Disclaimer.html internally within Tech Mahindra.
==================== =====3D=
==================== =====3D=
==================== =====3D=
==================== =====3D=
==================== ====
------_=_NextPart_001_01C7551C.302725D3--
RE: install_driver(Oracle) failed while connecting to oracle 10.2.0.2
am 20.02.2007 19:25:06 von Philip.Garrett
------_=_NextPart_001_01C7551C.7217FB16
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
You need to rebuild DBD::Oracle against the new 10g client you
installed. You don't necessarily need to upgrade (which would be a good
idea though), but you DO need to rebuild it.
________________________________
From: RaviChandra Chelikam [mailto:rchelikam@TechMahindra.com]=20
Sent: Tuesday, February 20, 2007 1:23 PM
To: Garrett, Philip (MAN-Corporate)
Cc: dbi-users@perl.org
Subject: RE: install_driver(Oracle) failed while connecting to
oracle 10.2.0.2
=09
=09
Philip
We have Changed the permissions .
Even after that, I am getting the following error as
=20
=20
install_driver(Oracle) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBD/ Oracle/Oracl
e.so' for module DBD::Oracle: ld.so.1: perl: fatal: libclntsh.so.9.0:
open failed: No such file or directory at
/usr/local/lib/perl5/5.6.1/sun4-solaris/DynaLoader.pm line 206.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where
expected
at a.pl line 25
=20
=20
=20
Actually it is searching for libclntsh.so.9.0(since the previous
oracle version was 9i) in
/usr/local/opt/oracle/product/10.2.0/lib32/and=20
Failing to open the file.
But since we migrated to 10g now
/usr/local/opt/oracle/product/10.2.0/lib32/ is having libclntsh.so.10.1
=20
So, what should I do ,to point to libclntsh.so.10.1 instead of
libclntsh.so.9.0
=20
=20
=20
Thanks & Regards
Ravi
=20
-----Original Message-----
From: Garrett, Philip (MAN-Corporate)
[mailto:Philip.Garrett@manheim.com]=20
Sent: Tuesday, February 20, 2007 9:47 PM
To: RaviChandra Chelikam; dbi-users@perl.org
Subject: RE: install_driver(Oracle) failed while connecting to
oracle 10.2.0.2
=20
Hi,
=20
RaviChandra Chelikam wrote:
>=20
> perl: fatal:
> /usr/local/opt/oracle/product/ldcnmd/lib32/libclntsh.so.9.0:
> Permission denied at .....
^^^^^^^^^^^^^^^^^
=20
The permissions on your Oracle installation are not letting Perl
load
the Oracle client library. The library file libclntsh.so.9.0
(or one of
the directories leading to it more likely) is not accessible as
the user
running the Perl script. Fix the permissions and your program
will
probably work ok.
=20
Regards,
Philip
==================== =====3D=
==================== =====3D=
==================== ==
==================== =====3D=
==================== =====3D=
==
Tech Mahindra, formerly Mahindra-British Telecom.
Disclaimer:
This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review at http://www.techmahindra.com/Disclaimer.html externally and
http://tim.techmahindra.com/Disclaimer.html internally within Tech
Mahindra.
==================== =====3D=
==================== =====3D=
==================== ==
==================== =====3D=
==================== =====3D=
==
=09
------_=_NextPart_001_01C7551C.7217FB16--
RE: install_driver(Oracle) failed while connecting to oracle 10.2.0.2
am 21.02.2007 16:14:36 von Philip.Garrett
I've already answered this off-list. Here's the entire thread for
posterity:
=20
You need to:
=20
1) Transfer the .tar.gz to the remote machine
2) Unpack it there
3) cd into DBD-Oracle-1.15
4) read the README and follow the instructions.
=20
You will need a C compiler on that machine, and you'll need a "full"
install of the Oracle client (meaning it has the headers necessary to
compile OCI and Pro*C applications).
------------------------------------------------------------ ------------
--------
From: RaviChandra Chelikam [mailto:rchelikam@TechMahindra.com]=20
Sent: Tuesday, February 20, 2007 2:11 PM
To: Garrett, Philip (MAN-Corporate)
Subject: RE: install_driver(Oracle) failed while connecting to oracle
10.2.0.2
Philip
I Have downloaded the DBD::Oracle 1.15 from the link u have given and
copied to my local machine.
Should I compile it first in my local machine and then kept it in the
remote machine where the oracle 10g is installed .
=20
Else
Should I directly copy the whole folder DBD::Oracle 1.15 to remote
machine and then compile.
Actually the folder structure of DBD::Oracle 1.15 which I downloaded
from the cpan link and the one which is already existing in remote
machine is different.
There is not even Makefile.pl file in the remote machine.
=20
Then how could I compile it in the remote machine.
=20
Could u plz let me know.
=20
=20
Thanks & Regards
Ravi
=20
=20
------------------------------------------------------------ ------------
--------
From: Garrett, Philip (MAN-Corporate)
[mailto:Philip.Garrett@manheim.com]=20
Sent: Wednesday, February 21, 2007 12:29 AM
To: RaviChandra Chelikam
Subject: RE: install_driver(Oracle) failed while connecting to oracle
10.2.0.2
=20
(2) is probably the safest route (least likely to require code changes).
=20
(3) is probably best long-term, but it might also require upgrading Perl
and DBI.
=20
------------------------------------------------------------ ------------
--------
From: RaviChandra Chelikam [mailto:rchelikam@TechMahindra.com]=20
Sent: Tuesday, February 20, 2007 1:53 PM
To: Garrett, Philip (MAN-Corporate)
Subject: RE: install_driver(Oracle) failed while connecting to oracle
10.2.0.2
Philip
Sorry for disturbing u again.
Since I am new to perl , I am getting many doubts. Thanks for ur
patience and helping me .
=20
1. Could u plz let me know whether , i should rebuild the existing
DBD::Oracle 1.15 which is already existing in my application.
If so, could u plz tell me the steps how to rebuild DBD::Oracle
against the new 10g client .
2. Else should I download the DBD::Oracle 1.15 from the path u have
given and then rebuild against the new 10g client.
=20
3. Else should I download new version of DBD::Oracle and then rebuild
against the new 10g client.
=20
=20
Thanks & Regards
Ravi
=20
------------------------------------------------------------ ------------
--------
From: Garrett, Philip (MAN-Corporate)
[mailto:Philip.Garrett@manheim.com]=20
Sent: Tuesday, February 20, 2007 11:55 PM
To: RaviChandra Chelikam
Cc: dbi-users@perl.org
Subject: RE: install_driver(Oracle) failed while connecting to oracle
10.2.0.2
=20
You need to rebuild DBD::Oracle against the new 10g client you
installed. You don't necessarily need to upgrade (which would be a good
idea though), but you DO need to rebuild it.
=20
------------------------------------------------------------ ------------
--------
From: RaviChandra Chelikam [mailto:rchelikam@TechMahindra.com]=20
Sent: Tuesday, February 20, 2007 1:23 PM
To: Garrett, Philip (MAN-Corporate)
Cc: dbi-users@perl.org
Subject: RE: install_driver(Oracle) failed while connecting to oracle
10.2.0.2
Philip
We have Changed the permissions .
Even after that, I am getting the following error as
=20
=20
install_driver(Oracle) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBD/ Oracle/Oracl
e.so' for module DBD::Oracle: ld.so.1: perl: fatal: libclntsh.so.9.0:
open failed: No such file or directory at
/usr/local/lib/perl5/5.6.1/sun4-solaris/DynaLoader.pm line 206.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at a.pl line 25
=20
=20
=20
Actually it is searching for libclntsh.so.9.0(since the previous oracle
version was 9i) in /usr/local/opt/oracle/product/10.2.0/lib32/and=20
Failing to open the file.
But since we migrated to 10g now
/usr/local/opt/oracle/product/10.2.0/lib32/ is having libclntsh.so.10.1
=20
So, what should I do ,to point to libclntsh.so.10.1 instead of
libclntsh.so.9.0
=20
=20
=20
Thanks & Regards
Ravi
=20
-----Original Message-----
From: Garrett, Philip (MAN-Corporate)
[mailto:Philip.Garrett@manheim.com]=20
Sent: Tuesday, February 20, 2007 9:47 PM
To: RaviChandra Chelikam; dbi-users@perl.org
Subject: RE: install_driver(Oracle) failed while connecting to oracle
10.2.0.2
=20
Hi,
=20
RaviChandra Chelikam wrote:
>=20
> perl: fatal:
> /usr/local/opt/oracle/product/ldcnmd/lib32/libclntsh.so.9.0:
> Permission denied at .....
^^^^^^^^^^^^^^^^^
=20
The permissions on your Oracle installation are not letting Perl load
the Oracle client library. The library file libclntsh.so.9.0 (or one of
the directories leading to it more likely) is not accessible as the user
running the Perl script. Fix the permissions and your program will
probably work ok.
=20
Regards,
Philip
==================== =====3D=
==================== =====3D=
==================== ==
==================== =====3D=
==================== =====3D=
==
Tech Mahindra, formerly Mahindra-British Telecom.
Disclaimer:
This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review at http://www.techmahindra.com/Disclaimer.html externally and
http://tim.techmahindra.com/Disclaimer.html internally within Tech
Mahindra.
==================== =====3D=
==================== =====3D=
==================== ==
==================== =====3D=
==================== =====3D=
==
=20
=20
==================== =====3D=
==================== =====3D=
==================== ==
==================== =====3D=
==================== =====3D=
==
Tech Mahindra, formerly Mahindra-British Telecom.
Disclaimer:
This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review at http://www.techmahindra.com/Disclaimer.html externally and
http://tim.techmahindra.com/Disclaimer.html internally within Tech
Mahindra.
==================== =====3D=
==================== =====3D=
==================== ==
==================== =====3D=
==================== =====3D=
==
=20
=20
==================== =====3D=
==================== =====3D=
==================== ==
==================== =====3D=
==================== =====3D=
==
Tech Mahindra, formerly Mahindra-British Telecom.
Disclaimer:
This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review at http://www.techmahindra.com/Disclaimer.html externally and
http://tim.techmahindra.com/Disclaimer.html internally within Tech
Mahindra.
==================== =====3D=
==================== =====3D=
==================== ==
==================== =====3D=
==================== =====3D=
==
=20